class CreateQuotes < ActiveRecord::Migration
  def self.up
    create_table :quotes do |t|
      t.column  :customer_id,     :integer
      t.column  :quote_number,    :string
      t.column  :description,     :string
      t.column  :price_per_hour,  :decimal, :precision => 8, :scale => 2
      t.column  :hours,           :decimal, :precision => 8, :scale => 2
      t.column  :total_price,     :decimal, :precision => 8, :scale => 2
      t.column  :created_on,      :timestamp
      t.column  :updated_on,      :timestamp
      t.column  :lock_version,    :integer, :default => 0
    end
  end

  def self.down
    drop_table :quotes
  end
end